CREATE TABLE [dbo].[SystemConfigParameterRef]
(
[ParameterName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SystemKeyword] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PropertyDefinitionKey] [uniqueidentifier] NULL,
[Description] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultParameterValue] [nvarchar] (2500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[SystemConfigParameterRef] ADD CONSTRAINT [PK_SystemConfigParameterRef] PRIMARY KEY CLUSTERED ([ParameterName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PARAMETERNAME] ON [dbo].[SystemConfigParameterRef] ([ParameterName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SystemConfigParameterRef_PropertyDefinitionKey] ON [dbo].[SystemConfigParameterRef] ([PropertyDefinitionKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SystemConfigParameterRef_SystemKeyword] ON [dbo].[SystemConfigParameterRef] ([SystemKeyword]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SystemConfigParameterRef] ADD CONSTRAINT [FK_SystemConfigParameterRef_PropertyDefinition] FOREIGN KEY ([PropertyDefinitionKey]) REFERENCES [dbo].[PropertyDefinition] ([PropertyDefinitionKey])
GO
ALTER TABLE [dbo].[SystemConfigParameterRef] ADD CONSTRAINT [FK_SystemConfigParameterRef_SystemRef] FOREIGN KEY ([SystemKeyword]) REFERENCES [dbo].[SystemRef] ([SystemKeyword])
GO